/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80032 (8.0.32)
 Source Host           : localhost:3306
 Source Schema         : renli_manager

 Target Server Type    : MySQL
 Target Server Version : 80032 (8.0.32)
 File Encoding         : 65001

 Date: 27/03/2023 20:56:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for staff_work
-- ----------------------------
DROP TABLE IF EXISTS `staff_work`;
CREATE TABLE `staff_work` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `staff_id` bigint NOT NULL COMMENT '员工id',
  `department` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '所属部门',
  `contract_period` datetime DEFAULT NULL COMMENT '合同期限',
  `contract_begin` datetime DEFAULT NULL COMMENT '合同开始时间',
  `contract_end` datetime DEFAULT NULL COMMENT '合同结束时间',
  `probation_time` datetime DEFAULT NULL COMMENT '转正时间',
  `entry_time` datetime DEFAULT NULL COMMENT '入职时间',
  `employment_form` varchar(255) DEFAULT NULL COMMENT '聘用形式',
  `update_time` datetime NOT NULL,
  `update_people` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `work_id` (`staff_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1639965997887897603 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of staff_work
-- ----------------------------
BEGIN;
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (2, 8, '劳动部', '2023-03-13 20:41:34', '2023-03-19 20:41:42', '2023-03-17 20:41:45', '2023-03-18 20:41:50', '2023-03-12 20:41:55', '被骗过来的', '2023-03-08 20:39:42', '324');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (3, 3, '采购部', '2023-03-13 20:42:16', '2023-03-07 20:42:28', '2023-03-31 20:42:32', '2023-03-18 20:42:37', '2023-03-18 20:42:41', '什么贵', '2023-03-21 19:37:26', '待定');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1638083919410663426, 1638083918693437443, 'ergve', '2023-03-01 19:20:45', '2023-03-22 19:20:47', NULL, NULL, NULL, NULL, '2023-03-16 19:20:55', 'vev');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1638083919410663427, 1638083918693437444, 'rb', NULL, NULL, NULL, NULL, NULL, NULL, '2023-03-05 19:22:00', 'g');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639196442810892290, 1639196442747977730, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-24 17:41:43', 'root');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639883785976922113, 1639883785855287298, '采购部', NULL, NULL, NULL, NULL, NULL, '很强', '2023-03-26 14:55:37', '林大小');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639893761990533122, 1639893761873092610, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 15:35:15', '徐先知');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639893783234682881, 1639893783121436673, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 15:35:20', '徐先知');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639893804126511105, 1639893804017459201, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 15:35:25', '徐先知');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639893824624074753, 1639893824196255745, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 15:35:30', '徐先知');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639893842831548417, 1639893842714107906, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 20:14:20', 'root');
INSERT INTO `staff_work` (`id`, `staff_id`, `department`, `contract_period`, `contract_begin`, `contract_end`, `probation_time`, `entry_time`, `employment_form`, `update_time`, `update_people`) VALUES (1639965997887897602, 1639965997678182402, '人力部', NULL, NULL, NULL, NULL, NULL, '保送北大la', '2023-03-26 20:22:18', 'root');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
